SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569643 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569643 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504687,242811,707828,895389,842255,400723,886505,910893,497990,211336,161515,654487,130074,58338,642555,925414,839100,656567,310107,268064,597840,261836,464640,260974,411482,162843,311352,198244,216043,429875,285453,41004,451544,199797,447929,946801,398999,781876,276325,113758,525787,18223,4324,1039281,257891,663443,626060,803502,654926,753053,930312,444283,630716,347090,822266,701245,260654,1025294,539723,410774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]