SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002956s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417303 LIMIT 1 [ RunTime:0.001399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417303 [ RunTime:0.004754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323390,719666,732716,627169,306525,999578,810604,201328,81709,514748,288712,622150,41006,400599,281011,735445,295280,130431,793374,448656,252650,135585,240749,366052,396699,818494,852735,240254,455394,927470,295634,966096,81800,449375,714918,83177,1032518,131279,291506,767143,232070,132100,745496,429087,682340,128598,684667,935361,170152,983195,499116,358512,295451,489250,193132,349462,865613,417567,542626,124491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]