SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253940 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253940 [ RunTime:0.004473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305064,845505,759386,402485,1002945,459487,676450,990721,850451,1016841,993192,195675,81003,671136,531224,938221,1032980,918724,889598,889741,374546,225772,398774,714744,438253,304037,652946,379410,107438,358665,66664,1039845,372784,913567,727488,138953,1020492,977386,44254,1021282,950444,810798,436790,448978,387599,725091,38512,550914,986301,670295,7715,616099,584284,48287,760470,249124,135988,662533,390692,509556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]