SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545099 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545099 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725049,530604,733901,392383,50940,534352,160215,236914,422856,192342,466589,178886,420872,1040426,245965,551757,979497,715758,309827,845806,273496,862492,942802,123992,887987,736189,851913,801958,334864,825696,286617,342778,419069,389270,1015241,891680,275850,189426,53121,214338,561722,152747,1029763,727408,691735,299684,235742,225977,340360,885211,988535,423532,940899,977965,639664,836802,364740,679949,508905,356248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]