SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501142 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501142 [ RunTime:0.003480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891368,486162,51435,706386,378305,1005607,513292,786505,693489,469561,731962,281464,811565,276291,1014152,11462,548995,35085,675396,757642,930601,792250,420885,268967,557834,745049,465419,67808,429056,1044882,22263,317947,514872,183497,898611,395636,227947,137250,836170,862435,1041543,446493,171682,314256,484061,958370,611000,925867,83092,404161,185955,470681,549914,32678,183645,230462,148491,418904,320499,979302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]