SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491998 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491998 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54908,810619,389698,989186,255787,406728,253175,140697,392115,978426,885804,672093,703867,478794,361190,394547,568122,1006679,306868,388221,938219,968746,218039,363059,998475,797228,15190,495922,88013,55366,811580,969561,494905,170921,636405,823532,66233,104782,148846,811897,27467,1016917,671513,714356,47411,953620,115910,868830,711405,777662,298693,662092,547619,263189,821201,275841,790246,862486,809623,987153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]