SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544309 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544309 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808478,126525,970124,781188,570687,708984,328241,473479,896400,878363,409723,634149,916063,251415,822466,347721,994068,287955,465618,439342,112006,76642,575382,417837,709544,567742,75484,789511,917168,765327,515077,758605,485781,234578,962383,972131,608473,2693,878417,261451,683844,524321,458578,327959,907302,394743,178175,915198,656660,135287,963977,861913,965674,216488,616285,41888,400946,675058,573657,54111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]