SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314978 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314978 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757796,696389,821695,381364,859358,892259,1032370,474748,650241,291169,499355,1041631,545916,913120,845317,533484,432245,658662,295333,478516,51244,396017,258300,33568,335290,951869,1034560,108727,38728,360981,208024,411656,895072,848838,749197,327504,1028185,622841,366178,347422,883396,968762,656649,1012953,236850,198601,708937,455410,224540,51877,857489,763278,679968,177339,108152,981499,554053,3966,554648,965313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]