SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 970983 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 970983 [ RunTime:0.003980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546184,532872,391849,994604,387063,356496,684403,779127,461164,582108,65068,665103,871187,22265,973458,920836,296294,415725,279378,145452,903014,725232,533612,347364,352584,743717,577906,579655,930489,947940,562818,751999,704559,36471,270769,311254,151944,1000937,482628,81790,198487,997235,371728,87161,911507,542929,1000389,233091,1018160,93549,242537,549355,209695,1047888,588408,761610,926930,35906,534881,948378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 970983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 970983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]