SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602118 LIMIT 1 [ RunTime:0.003810s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602118 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529743,801462,54193,882400,78404,104030,653606,14418,1019925,412485,753057,230441,853288,545744,922774,688710,692360,198266,637076,747353,214871,648306,713442,166053,1043689,157144,658252,574469,130842,585199,346814,8951,255571,1032439,782426,316047,382276,318675,209696,454388,728540,804813,898743,29927,610039,849074,555719,691051,933170,743900,695409,512848,901418,678759,849078,940227,362162,369875,200259,666760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002098s ]