SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506327 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506327 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537524,66482,118235,10685,944139,826662,355272,665117,571188,658664,211986,524825,800127,68487,610148,518980,694551,674105,774621,687029,460977,273165,445115,355169,416078,348536,376761,473577,608094,771273,1032573,217220,391747,386969,804208,586699,407404,610747,523489,569774,1024033,510407,352404,545964,463186,133902,151071,802074,200837,1026292,905815,1046880,169578,111813,838423,216352,714881,644608,852182,866636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]