SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281941 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281941 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524578,296162,878016,585058,48977,405911,645926,292890,595570,543067,220098,726390,420890,57808,194112,697649,1010856,210252,750078,31888,660902,367252,764417,601493,634131,135333,995025,270825,90189,874458,886016,130544,82671,429358,969512,774538,553967,336587,790427,1001372,490537,140785,510091,1027526,480690,128678,870450,315342,572701,483908,371155,676669,985841,1019910,49007,701193,826425,647740,783192,306141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]