SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405618 LIMIT 1 [ RunTime:0.001485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405618 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263744,827861,695432,9118,493105,537971,644359,1024852,248624,308113,516633,59546,725234,688782,976285,235682,85803,75109,459124,219606,934977,481331,13066,52812,328822,453800,419535,865756,11917,72725,245272,647873,285221,1025764,38717,765711,775969,104293,861993,686122,681091,40456,1019116,76587,391258,102547,1045017,622754,549039,957095,4891,497512,485832,125525,752090,162437,73553,150465,467713,240685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005502s ]