SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464842 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464842 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470259,68490,272978,963388,315293,108940,727943,44339,994128,436857,505534,300383,925198,870991,144254,625635,1014893,269605,61103,903322,58505,675304,711008,833865,720878,395463,1038606,1033138,386465,757448,899354,865185,991905,706563,201786,714344,385094,195024,1017690,161867,600321,52199,551662,697589,165529,778325,1042448,16587,724569,201584,561236,961540,243000,507828,403091,716331,147083,176078,820087,783889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001049s ]