SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533001 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533001 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682896,535927,156961,328789,529079,234454,786103,535481,529543,1039309,192307,459809,919861,197734,118183,39281,783419,174934,474011,248602,665207,454862,270622,395192,280214,994602,250902,410787,321618,973232,980761,29785,124104,852594,473473,91694,195574,37541,654977,362771,127186,406107,737617,278555,975841,792946,9255,443661,989323,579007,846095,62508,232271,364026,480808,1021263,486255,551943,524496,492904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]