SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394509 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394509 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274404,178204,1026312,966367,219339,150676,1002614,2100,106229,986377,757169,366210,578507,892693,411604,833143,840806,976209,784871,436363,364809,471634,742697,833178,155468,174546,346808,583198,115226,716882,475304,357538,152657,995885,111821,415837,399122,537477,589165,446827,413779,229451,863205,178609,959894,669664,336165,522283,986005,493449,796891,396672,725236,36307,653002,731109,811288,416282,719513,914953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]