SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536214 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536214 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216882,760361,19516,566397,77491,682225,414455,104943,20601,355613,589584,839721,862690,812950,880508,510252,147795,325990,846573,450126,590707,903861,540026,942418,405121,1024123,325133,599500,637278,435070,1021740,861265,502514,258949,56734,934074,295448,874948,54144,600566,761376,160682,358996,572324,795374,228864,300161,460193,825653,344612,365595,720449,292958,90101,229509,246814,563746,54365,895446,425258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001068s ]