SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910306 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910306 [ RunTime:0.003285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160043,686435,510226,165779,146698,328616,782495,432344,590081,558685,360453,619109,800938,883490,310580,780772,483431,511875,134162,827485,862699,185714,486679,889236,285492,967036,519580,803889,106612,350151,739437,506185,875372,318793,498028,618408,33759,547694,278235,56535,684159,306177,569327,422626,512377,296436,395832,140296,1028879,234148,672341,343639,446032,207192,260501,52307,638206,196172,420121,116211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001048s ]