SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 374180 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 374180 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012960,224021,165035,886191,371127,589930,653973,147307,938369,52760,421980,678085,397241,5481,446195,785934,962831,618597,10481,1007772,26009,734630,516030,1048852,933987,393444,999441,542561,167205,253610,98823,954668,848470,494795,214482,326208,825176,817981,380880,896872,77114,434164,199329,1030903,67298,114623,353826,318878,183449,933775,641380,53586,411252,294421,58403,664545,392345,937393,173026,696396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 374180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 374180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]