SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503228 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503228 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412277,62914,477663,442546,427114,489754,113647,748291,587320,148884,15757,463072,946144,672465,334113,809204,719462,287005,210912,955001,530195,424426,647453,694616,692490,926202,688813,36301,813555,191604,29578,514561,217513,96550,685915,499736,553083,414833,64285,214169,946453,99110,634504,536764,930658,205280,730324,79507,514503,1003330,495339,942388,277152,6584,267131,627575,549822,446722,871265,798392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]