SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504437 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504437 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939801,341193,321493,757153,425406,582376,410783,400493,690473,287819,864430,338717,416664,810525,658291,612082,1006530,729461,478907,41609,976521,538401,757556,436675,426747,664973,966697,419854,755975,654209,392492,362087,213005,648025,983597,311802,703478,178537,941607,276949,788758,510627,419955,643444,749131,336283,908929,268759,592968,120998,669112,842895,931204,553909,317974,1041424,289331,977069,558419,89190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]