SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511581 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511581 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991855,494674,207846,475404,453166,53849,267855,812923,507862,711475,511985,651497,532734,283881,581370,861699,595548,673955,739994,285872,273549,352764,955052,305801,953394,715355,279980,319500,168294,12757,64145,4111,621966,1039563,83655,685643,329443,239477,573285,719541,1033394,979537,793630,213758,10284,448354,681387,1013282,944885,293840,868598,846040,168909,13214,917301,631625,836084,385368,279012,18818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]