SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548411 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548411 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103709,82857,235992,453898,543554,654831,716240,783671,920063,192619,369747,444650,858510,268397,760670,603979,1015755,62154,275945,693248,258664,543708,913788,975984,131024,125581,336357,157168,29088,974532,634704,73565,45875,671976,868829,540205,666101,854521,617530,336361,246705,25583,259417,652448,122660,997149,447143,359067,966204,42743,386593,1003205,338682,201536,237386,566254,415776,985307,858234,242351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]