SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556627 LIMIT 1 [ RunTime:0.000524s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556627 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162218,36786,436528,713409,993023,542698,496538,515031,1011143,828602,114031,365130,153474,727060,175159,413628,326496,1033996,676273,577180,27622,145012,72677,928297,542080,162522,848625,363424,746371,569194,853886,751506,973517,166730,957028,593473,701903,994698,895825,926763,930213,356235,653619,508438,167536,723280,252911,342822,211140,899521,1031214,929580,518726,901272,361598,694199,186682,61718,932587,705420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001318s ]