SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019403 LIMIT 1 [ RunTime:0.000838s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019403 [ RunTime:0.003046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861353,708087,835020,288943,565971,320547,177240,311247,118934,148959,220713,940439,165021,473036,798554,711169,184818,300892,580252,4243,530742,219553,805769,147973,71751,218768,381641,668079,776505,879421,922335,737470,679784,706725,384894,18799,247034,954233,358749,815859,640380,145525,702592,190568,639103,796019,587757,984828,633245,477741,1002325,410272,597831,224837,772569,247035,642922,916509,893793,934956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]