SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473436 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473436 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120894,169914,320517,450013,957900,977835,1019420,11268,966672,497536,532837,502875,734835,457,964017,803761,669815,628256,404156,639959,702554,129491,727066,236479,907006,565804,282780,3354,666547,665929,669037,30049,558799,246669,557498,273811,163676,261590,687593,244893,38077,301178,211583,177146,404482,753713,171274,37354,28120,363781,598369,598384,476154,399434,927092,180152,516401,396134,693561,939741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]