SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283541 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283541 [ RunTime:0.003134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165802,469414,684933,319168,813733,791814,363610,783748,689707,270762,79411,88559,102041,1032251,355104,357872,70299,330509,884056,770279,551314,115633,786133,156840,1035896,240837,949043,1021851,1041668,580051,773974,312038,562793,792028,662737,769592,975533,351392,159773,851299,847621,270264,233885,1007362,15389,666916,439888,262870,800970,575342,137124,176196,723849,614371,631126,347254,530916,714072,283356,1023514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]