SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417272 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417272 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145390,711262,424905,718386,340922,661916,326068,1040878,317860,632129,1028185,898799,449476,157306,80050,584757,592555,75929,456329,122460,869606,201102,815216,977539,946012,341387,520647,141648,900040,345792,636069,578621,583347,207336,709351,376724,221082,618749,131667,1041397,102061,801716,642621,885253,442045,754061,337143,825654,901214,950690,564710,280837,243346,911220,921118,190167,182660,538761,751702,625409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]