SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535827 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535827 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98018,865928,1037780,535398,111603,411186,450499,654145,456950,400615,1004604,1041566,150444,592764,408977,451282,106031,845779,556747,462799,105584,872909,411312,1042454,718220,12555,283699,28331,790918,898323,967622,509926,14617,949068,138400,619256,213547,820301,411788,629295,290213,443058,594517,326595,617490,1013162,223454,534738,669323,748557,40381,936059,831844,424338,996373,373824,24585,373359,379053,198704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]