SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642151 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642151 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290362,342869,686378,388822,156824,955586,837074,881408,387161,115869,979033,905510,336216,390983,909976,18322,647727,818600,114429,647747,535434,582005,1043917,907060,496799,657496,815384,323300,178203,115133,226801,573799,735221,462180,202313,598503,620001,5358,538364,973509,299300,751440,297061,290100,442287,450301,673580,583428,51939,526398,446199,959536,1005412,997985,847849,48106,878698,291610,1048843,435586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001822s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]