SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498923 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498923 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95792,812704,211134,349137,268324,679605,1028018,255593,740499,641233,887336,371088,784925,331597,47590,727570,805692,850741,598855,963294,10881,441491,476620,559774,970060,887212,121705,985721,988734,265514,351993,39896,937926,899051,214003,472542,623271,75883,732127,759310,711104,832921,700801,732943,643716,136398,781926,933938,234465,619247,348718,772184,691627,26785,723955,387542,679523,49366,443081,167255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]