SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330915 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330915 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532261,1041257,659598,398706,993469,375779,418922,196551,262567,716225,283281,944658,414943,199077,381460,566168,1035283,340628,431409,962148,467806,548263,24076,405979,190446,91268,735424,351682,150545,292492,872777,803562,53498,922983,462482,196443,390384,1004266,719197,946137,167999,607949,273562,79855,65437,736496,45195,950435,610980,112536,201890,303235,624220,683031,564578,59892,920230,182285,498122,28991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]