SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545019 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545019 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245149,281040,969579,698832,261735,51495,209711,652346,192251,1048904,870911,744890,193606,621018,632197,937936,728338,945070,478995,150207,1031952,653956,920325,45581,209019,200169,517811,821167,900787,818928,183212,6507,372896,833038,242123,175115,462674,318179,167315,874442,639714,484566,432434,701121,178138,110500,148520,885102,567205,608949,210774,198520,694920,895156,904062,579299,678226,937892,311829,687265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]