SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520271 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520271 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802031,98852,616773,95860,486829,913679,402751,865435,653789,621918,1041585,79918,529358,414450,628927,620802,1033593,892837,828117,869970,1013284,333266,296520,496840,73756,844399,905167,655386,603456,513511,411504,129311,440626,789142,658356,781900,71125,439344,166834,540790,260529,847019,87100,499897,980880,399605,55899,956107,253430,943333,9051,398974,613328,539949,716760,654554,889073,1005114,382748,854543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]