SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113818 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113818 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397729,355870,396001,233772,663209,236744,576872,197886,384637,739907,544213,438718,690196,803070,102620,451392,307091,939304,286476,813430,664975,171600,318979,350520,260434,350012,50180,827306,79333,976602,651053,318224,630841,139676,970627,269671,305444,199724,98463,487608,1007835,185201,330734,690619,299028,47910,376328,234022,447163,791557,271860,466682,297425,348896,37536,720873,799478,618143,536080,1015504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]