SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531881 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531881 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839549,186560,701502,771420,133698,311695,160476,283299,309313,145208,44314,516796,119310,933855,849463,42814,287688,792245,115914,100256,116120,896888,291499,1001379,87197,986221,115738,128688,601204,422147,527609,272133,754872,891107,187656,638916,149145,180160,688329,669402,870033,561373,545952,613945,765678,646999,679315,465264,425718,624637,130568,898662,190822,747792,348048,45574,485949,1047365,600928,254558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]