SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4178 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4178 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641397,823683,482987,920847,974371,614908,261989,571029,699847,776787,677987,453288,270978,730943,875575,508026,733889,1044466,927869,640544,534018,193814,541747,408982,273775,770568,584979,395924,41128,1002460,94765,65656,520496,350566,484195,149721,759781,761037,952559,680605,120378,886842,774711,405297,3590,111749,822034,139817,674034,872102,212814,870482,986553,839315,329510,1027520,224900,568036,717890,795553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]