SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427864 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427864 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259907,257592,151041,74142,1038649,245862,9181,121662,399786,539095,181565,184770,745407,604077,275390,964230,475793,269530,710609,379667,1034270,164979,783835,159638,230088,38219,259164,920953,894753,243611,530705,306215,508387,435489,756249,39444,651449,19675,42755,82292,757896,953220,679639,224441,750669,542708,230893,763345,173505,398515,545505,881952,443051,543123,994736,68603,725094,545509,83500,151301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]