SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31905 LIMIT 1 [ RunTime:0.001265s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31905 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373508,394755,688585,616585,338000,143844,803779,299610,261818,477206,686804,185526,596289,274837,329461,910056,242142,168047,237570,626266,925336,69523,627451,701514,432284,468099,1012639,781385,144391,728173,887652,804870,846915,905324,693442,774707,233556,1003296,985653,981752,996215,465356,117001,221219,54792,171985,747010,770329,219913,130533,35432,825062,778789,473275,471663,869134,689706,186269,92418,647445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]