SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531874 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531874 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485755,296982,652251,590652,798951,147225,651188,48403,549739,989403,234290,1021530,37165,210672,523670,675731,632449,1039870,905562,584144,747950,496703,327944,632414,826891,740838,691983,811013,1048130,408595,290879,531675,376267,439613,526676,231339,930321,179702,662708,687197,494660,558287,133273,581548,159011,953710,113471,650002,468658,368189,1025629,182353,502783,813598,434101,297734,743394,248491,878169,232319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531874 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531874 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]