SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047454 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047454 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021142,1008410,152996,233896,40257,732241,446452,937427,103375,397355,2713,15059,193005,986550,917407,996622,333819,275379,216439,789030,570663,323987,18213,1003752,346,973473,343341,116542,384012,795992,1028497,523270,498962,187117,623819,260607,1002692,287093,164571,988565,606061,909519,418027,584729,244671,56360,866892,555773,665609,760591,871049,740610,186843,549841,698744,783539,357918,328857,242895,274994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]