SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474505 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474505 [ RunTime:0.003589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38835,469131,796904,636782,163395,1005187,595008,485823,32293,682497,691683,728541,158946,68684,673787,491644,97031,683940,18946,287900,70553,552767,509826,901845,17542,1143,546805,733144,169742,564745,736614,146541,857781,441922,869591,287566,56037,878059,884728,760508,881787,680534,376869,259569,602747,319738,374314,394095,475182,306162,584864,561761,601382,1032878,308822,339381,761895,277957,639414,719276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]