SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569741 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569741 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375444,755913,568617,702024,415053,176156,297101,279040,610824,694015,865256,698476,393072,417818,665799,870189,130111,366556,894162,474789,767678,513777,625958,162109,462844,873261,977073,1015362,666073,577100,892354,1043291,331449,311481,847958,159175,792050,541730,538098,825770,562819,563522,61550,992872,1041999,207305,4842,315580,1021626,60175,955914,246710,139685,274308,772531,132346,1003065,692046,211879,607312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]