SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10428 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10428 [ RunTime:0.002315s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937338,281922,306641,423245,71024,197476,1021637,781286,707054,220610,871857,61205,198657,73841,124155,230815,773721,291735,981397,796940,927099,615865,576295,21619,159634,23920,40086,253190,1003011,519518,836651,480785,149310,28650,194592,766349,421744,106965,1026895,318780,896746,78521,274893,87501,136143,312575,238078,20974,661732,958093,1027564,660104,136587,1038964,1044956,259206,723903,223510,170203,349835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]