SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501451 LIMIT 1 [ RunTime:0.000765s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501451 [ RunTime:0.003864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363079,1047663,544067,937514,537681,670520,7004,461875,863668,37297,318678,758963,31084,394452,728544,661712,635205,889384,543562,255105,857258,982218,7506,62823,472530,688663,788196,817754,252895,262126,3220,650541,350141,656082,697658,367091,362732,768443,1014138,326085,487620,62174,403803,10238,237382,827431,93099,822258,921852,1007535,902183,645469,1017099,104880,195851,407758,544150,871486,490462,873517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]