SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534308 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534308 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647566,719638,165956,457287,928658,614942,618658,177674,547505,189087,523516,753783,143825,226265,150672,554374,187723,246180,160904,207014,676898,56079,278948,184793,1008290,392775,982283,951182,43357,927797,571497,327255,617470,422596,55119,441188,306975,940820,293115,730438,2413,747957,344523,217094,99096,686899,326114,264212,551377,920386,372734,528732,135999,651219,326545,61947,854875,323238,195198,1045345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]