SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501348 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501348 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872046,191646,108489,893722,252525,321189,1766,424258,659638,767112,449292,664352,203684,398328,438904,598322,564545,537097,929444,469425,422578,888487,546630,1046007,952794,323484,467935,710018,620032,582825,113596,499924,767718,179508,670762,1005457,535749,992607,429975,352459,150076,651321,909600,336701,148764,931579,711105,1017945,779163,321909,612480,166875,834774,592218,467784,206866,337893,139810,144300,421594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]