SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476238 LIMIT 1 [ RunTime:0.001100s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476238 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407586,116917,751329,189204,202883,172113,463138,95008,504562,1017322,163412,617214,490150,30334,977701,381154,554952,108267,580182,645401,265951,352803,248267,394562,542312,323592,866256,385806,497086,587535,582378,48883,430899,777364,117195,214771,811464,893421,968701,169169,18228,969888,607790,979033,147686,985367,172164,393747,872322,826200,960321,1012069,555767,747862,111106,923055,1024077,443320,635655,297163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000755s ]