SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001478 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001478 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003812,515213,407531,129717,253169,25930,489916,982112,931641,126838,817672,446389,46544,618143,193661,19981,695781,284602,462872,536737,405214,741890,438093,488648,90556,883481,130497,774602,910774,89960,857748,83088,468581,671950,377857,817101,348613,736629,174416,576196,230125,1016080,699292,440378,6566,103386,495816,409467,609490,1023101,197806,734422,870733,526916,239203,523065,627200,729577,384169,748442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]