SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488202 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488202 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143783,498986,862811,714508,439898,994155,40207,717434,496841,468198,1001550,296367,146450,523903,118766,901978,632944,440925,386006,625454,781925,254961,235097,244474,245038,84586,999417,127805,515952,880496,482647,104341,699057,761513,661167,555688,433918,870066,126614,486741,305370,40521,137016,432742,638769,901080,932743,607875,797186,27896,637713,458445,212746,989438,65736,337267,273407,580695,280862,971455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]