SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002773s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198993 LIMIT 1 [ RunTime:0.001423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198993 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64975,519844,677848,884932,633429,364019,943346,94615,498751,84336,490886,395946,511377,17339,1037154,350520,140386,685989,959077,320413,511006,645015,901793,500591,1021322,43826,187550,243547,866043,584275,1048546,96610,1008470,388579,733744,324261,243805,1000909,14549,129665,233425,461233,561347,642140,1046679,22451,128028,946124,340330,879552,644074,398038,20138,551701,980554,896743,577136,592068,686533,128085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002476s ]