SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414398 LIMIT 1 [ RunTime:0.000695s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414398 [ RunTime:0.003810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175419,283086,974486,414443,851268,550133,408731,20495,3888,165333,286833,879602,879554,527194,647235,907187,666508,417671,779410,403152,333251,163021,903998,128697,19868,846646,296352,415038,76591,878437,489407,688178,388763,289009,660959,598456,399746,1036359,72049,590360,178477,844148,729590,661526,507461,143586,578054,949267,743100,466556,175992,975126,76697,614132,743249,38930,637430,397281,1020628,484065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]