SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503441 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503441 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032748,999000,336978,312211,341772,18901,687520,4415,73393,500499,428730,719251,970188,353725,605426,784331,881919,156474,262163,6475,935715,780938,274827,896213,287157,870960,336753,617147,428017,539692,1026568,862501,643297,266511,924547,87001,108256,195073,113418,427964,165611,71238,80566,1017913,990735,407994,990884,230430,524721,295355,372124,109616,52992,149746,120629,559320,442558,20296,741039,87203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]