SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401978 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401978 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026152,953406,460648,788991,698614,290935,994451,389793,314365,83770,857798,116445,992797,727661,773697,391583,111484,685472,354369,465731,185250,1046467,609839,967426,110621,434199,257401,39337,33282,285511,278947,133001,642031,393867,652689,946972,118602,79636,251268,813946,279559,480887,274727,66584,441121,753752,173157,553266,51778,914916,941371,683038,692740,941397,861473,698311,7532,295505,322690,926307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001651s ]