SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200342 LIMIT 1 [ RunTime:0.000668s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200342 [ RunTime:0.002868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103518,571564,971878,344132,807671,370899,602679,564594,623232,223749,445645,1035785,845740,85169,621512,314436,890140,15867,565222,170107,862610,714279,382665,815460,712674,198275,380096,798971,860243,37545,194644,569148,30460,105725,967516,813306,115900,38390,844499,801908,48214,968627,50165,575263,692371,291984,85379,552743,511657,130026,984422,782300,360574,810338,280568,292026,338955,748118,314571,542946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]