SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020568 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020568 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690551,594099,24775,783160,675234,638650,463132,380806,950895,313584,83188,745029,966040,920248,1029886,827817,329160,323805,76510,925645,448741,176380,337352,119626,91461,1018700,341215,1026646,94746,140470,930849,750216,286938,257522,258537,747433,216280,695703,320435,413292,784722,583443,212277,307518,881937,682950,900281,789646,363347,310370,696188,363872,340114,369828,323186,202036,363349,62230,914953,185988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]