SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108923 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108923 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594222,156526,397384,814812,233082,366850,1032000,268505,34797,533888,15168,720284,1001912,527771,809312,821750,135105,25287,619434,350196,1000502,505434,231517,225708,508791,772222,199870,78127,303636,160818,678530,262650,47450,322059,1028196,1039168,230196,838419,486391,467561,866248,470979,638376,209074,910602,721077,254409,861785,328128,965764,389440,941880,336601,10514,420417,387535,563974,85544,997326,179510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]