SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404016 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404016 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100020,573894,861479,265594,310187,719209,827068,540104,708753,31434,14022,700760,785784,208472,903567,889981,142662,335843,362265,639603,491352,86747,351653,379429,209905,313552,373420,992331,109113,730765,574029,694086,537684,192868,845863,518814,264894,40169,939867,35853,405843,1007533,956078,517666,551530,188451,259072,193248,1022451,758741,471219,722474,28914,323199,311306,682846,729476,786467,261649,459934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]