SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029201 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029201 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808781,847531,755572,168715,943841,547274,1013735,353000,683903,319525,289159,453280,228794,207734,906871,56965,318685,464811,988761,669914,23357,556391,560365,753435,1048510,317654,872467,74529,1048880,833846,319099,652616,441551,544541,891877,287778,182325,939537,517073,549272,268879,206289,682829,526517,702676,989845,916333,909635,505395,565298,467699,385755,561758,106660,356557,934389,176177,652640,911219,227309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]