SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033490 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033490 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914917,880770,703940,936699,887739,470966,745494,959232,77663,610551,342538,389623,770999,928394,153353,616397,726677,167896,744188,83922,444857,494409,264436,781542,123315,839998,336964,472257,730788,162815,753478,147839,993966,226948,656151,276158,513880,104885,1002569,437330,672527,902108,260690,289166,509838,922423,360193,538441,321928,572689,303234,896058,869794,405240,1007858,265603,267932,642929,44850,321678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]