SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477876 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477876 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624995,372776,577834,274869,483999,549207,809291,736779,124457,1019411,989938,658730,77844,1018440,542786,376473,392573,409385,146933,581281,260651,1000614,666575,535511,969617,299395,687941,264904,1021907,900818,468435,150308,959767,183731,745112,500913,722560,33634,1039641,483243,643436,806354,337,264239,308995,161570,225236,198153,52344,305039,664792,963514,818898,986144,291862,124659,999801,920207,1041222,261578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]