SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020055 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020055 [ RunTime:0.002570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793909,382690,192278,503539,79954,33365,95354,1014984,936339,208417,716956,645338,1046498,323394,1002089,893074,43590,694196,605861,735831,726371,359356,509765,207701,441196,332768,751340,211765,819693,168024,554527,761274,910350,122784,364494,438729,913632,717862,64870,321662,302489,728186,741334,63950,562465,227492,568444,908244,948421,874944,997381,108656,883,605871,471793,77733,186701,466053,483858,1028812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001127s ]