SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039317 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039317 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85057,141404,47477,743148,684364,199644,382614,482236,361500,495113,339519,905751,758599,438458,842809,850008,870401,874512,601674,276295,447455,854130,977014,698628,17051,835458,520112,736100,273037,1019898,641386,862850,83426,970203,214728,774702,59995,101742,791927,537967,996251,710284,600333,523044,417052,207423,87648,772233,1047247,375039,571344,201918,545394,678162,737637,575604,706888,284252,732734,27353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]