SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019917 LIMIT 1 [ RunTime:0.000810s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019917 [ RunTime:0.002504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308446,438394,85014,864621,936676,195089,594226,720678,241099,139444,629666,205003,830365,857353,362291,991672,14297,536027,243874,573136,535548,521841,655058,133310,271539,792678,140784,502130,801236,993298,902709,410981,692921,967788,561379,878521,1021731,914254,118754,200824,675918,146415,978661,805422,935134,182620,668117,511579,140411,699738,88510,518536,470384,962915,875435,1021416,781087,715140,363342,931919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]