SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504970 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504970 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101583,657649,375344,75975,164370,660571,669285,904588,112312,173781,755430,246761,986812,428776,323917,640180,885108,64618,165227,712579,988800,5078,1019649,360049,32430,414480,363917,487221,976294,98116,899402,697202,484271,539659,719969,537851,857365,942913,331498,805220,747064,403318,394711,390539,830380,144481,486263,946972,732253,682698,244254,422599,213722,260549,1027863,732728,477438,129790,489580,986516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.009503s ]