SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42501 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42501 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014967,111756,916550,1026147,10402,247568,890849,386609,247843,167067,823079,250913,573356,84356,758364,887952,935917,72892,964467,953961,267372,512343,138553,924930,520638,471807,1006184,540891,370512,582456,82630,885753,1020425,265717,674514,965688,248376,221538,236570,36893,145789,921505,951710,149902,946144,289013,187973,609671,344336,896303,43142,138174,973306,815145,400172,670833,530401,307210,869792,908878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]